Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'VAT Registration No.' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to VAT REGISTRATION NO.

Seq No	Page Number	Page Name	Control Name
1	1	Company Information	VAT Registration No.
2	1	Company Information	VAT Registration No.
3	21	Customer Card	VAT Registration No.
4	26	Vendor Card	VAT Registration No.
5	42	Sales Order	VAT Registration No.
6	43	Sales Invoice	VAT Registration No.
7	44	Sales Credit Memo	VAT Registration No.
8	123	VAT Entries Preview	VAT Registration No.
9	132	Posted Sales Invoice	VAT Registration No.
10	134	Posted Sales Credit Memo	VAT Registration No.
11	249	VAT Registration Log	VAT Registration No.
12	249	VAT Registration Log	VAT Registration No.
13	315	VAT Entries	VAT Registration No.
14	741	VAT Report Subform	VAT Registration No.
15	1382	Customer Templ. Card	VAT Registration No.
16	1386	Vendor Templ. Card	VAT Registration No.
17	1572	VAT Entries Preview Subform	VAT Registration No.
18	1575	VAT Entries Preview Flat Subf.	VAT Registration No.
19	1803	Assisted Company Setup Wizard	VAT Registration No.
20	2107	O365 Sales Customer Card	VAT Registration No.
21	2110	O365 Sales Invoice	VAT Registration No.
22	2113	O365 Posted Sales Invoice	VAT Registration No.
23	2130	O365 Business Info Settings	VAT Registration No.
24	2141	O365 Sales Quote	VAT Registration No.
25	2310	BC O365 Sales Invoice	VAT Registration No.
26	2313	BC O365 Posted Sales Invoice	VAT Registration No.
27	2318	BC O365 Sales Customer Card	VAT Registration No.
28	2330	BC O365 Business Info Settings	VAT Registration No.
29	2341	BC O365 Sales Quote	VAT Registration No.
30	5050	Contact Card	VAT Registration No.
31	6630	Sales Return Order	VAT Registration No.
32	6660	Posted Return Receipt	VAT Registration No.
33	8629	Config. Wizard	VAT Registration No.

Dynamics 365 BC Table ReferencePage Control Search